/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : localhost:3306
 Source Schema         : hw_user

 Target Server Type    : MySQL
 Target Server Version : 50736
 File Encoding         : 65001

 Date: 23/01/2024 17:21:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `username` varchar(80) NOT NULL COMMENT '用户名',
  `password` varchar(80) NOT NULL COMMENT '密码的MD5',
  `role` tinyint unsigned DEFAULT '0' COMMENT '0-普通用户,1-管理员',
  `apikey` varchar(80) NOT NULL COMMENT '接口apikey',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  KEY `idx_t_user_deleted_at` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `created_at`, `updated_at`, `deleted_at`, `username`, `password`, `role`, `apikey`) VALUES (1, '2024-01-23 17:20:14', '2024-01-23 17:20:14', NULL, 'admin', '$2a$10$Eja99bKQ5vZG8YDAg8Kij.dugHgVIjr/OXUf/tImNeXmZ263UyCxi', 0, '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
